/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50744
 Source Host           : localhost:3306
 Source Schema         : deepgox-admin-db

 Target Server Type    : MySQL
 Target Server Version : 50744
 File Encoding         : 65001

 Date: 21/04/2025 12:22:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for manager
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `email` varchar(64) DEFAULT NULL,
  `gender` tinyint(4) DEFAULT '0',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of manager
-- ----------------------------
BEGIN;
INSERT INTO `manager` (`id`, `username`, `password`, `email`, `gender`, `create_time`, `update_time`) VALUES (14, 'lining', 'e10adc3949ba59abbe56e057f20f883e', 'realsoft@126.com', 0, '2025-03-07 07:41:44', '2025-03-07 07:41:44');
INSERT INTO `manager` (`id`, `username`, `password`, `email`, `gender`, `create_time`, `update_time`) VALUES (16, 'fffffff', 'e10adc3949ba59abbe56e057f20f883e', 'realsoft@qq.com', 1, '2025-04-21 04:08:20', '2025-04-21 04:08:20');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
